# 删除
import pymysql

if __name__ == '__main__':
    conn = pymysql.connect(host="localhost", port=3308, db="xuexiao", user="root", password="root1234")
    cursor = conn.cursor()
    i = int(input("学号"))
    sql = '''
    delete from student where no =%d
    '''
    print(i)
    r = cursor.execute(sql,  (i,))
    print("结果是", r)
    conn.commit()
    conn.close()